USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Employee_GetSalaryByEmployeeIDAndMonth]    Script Date: 02/10/2012 11:24:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		hainh
-- Create date: 26/12/2011

-- =============================================
CREATE PROCEDURE [dbo].[Employee_GetSalaryByEmployeeIDAndMonth]
                 @EmployeeID         BIGINT,
                 @Month              nvarchar(50),
                 @EmployeeSalaryID   BIGINT
AS
BEGIN            SELECT*
                 FROM EmployeeSalary A
                 WHERE (A.EmployeeID =@EmployeeID) and (A.Month = @Month)and (A.EmployeeSalaryID != @EmployeeSalaryID)
                     
 
	
END

GO

